Computer Science for IGCSE & O level - Databases (Section 5 - No. 35)
What are the advantages of using indexes in a database?
Faster data retrieval.
Improved data integrity.
Increased data storage space.
Faster data insertion and update operations.
Paliwanag
Indexes speed up data retrieval, but can slightly slow down insertion and update operations because the index needs to be updated as well.